<?xml version="1.0" encoding="utf-8" ?>
<Vulcan xmlns="http://tempuri.org/vulcan2.xsd">
  <Connections>
    <Connection Name="TestConnection1" Type="OleDB" />
  </Connections>
  <Packages>
    <Package Name="TestTable1" Type="Table">
      <Tasks>
        <ExecuteSQL Name="CreateTable" ConnectionName="TestConnection1">
          <Query QueryType="Standard">
            <Body>
              SET ANSI_NULLS ON
              SET QUOTED_IDENTIFIER ON
              GO

              -------------------------------------------------------------------
              IF EXISTS (SELECT * from sys.objects WHERE object_id = OBJECT_ID(N'[TestTable1]') AND type IN (N'U'))
              DROP TABLE [TestTable1]
              GO

              CREATE TABLE [TestTable1]
              (
              -- Columns Definition
              [Column1] int NOT NULL
              ,[Column2] int NOT NULL
              ,[VersionNumber] rowversion NOT NULL

              -- Constraints

              )
              ON [PRIMARY]
              WITH (DATA_COMPRESSION = NONE)
              GO

              -------------------------------------------------------------------

              CREATE  NONCLUSTERED INDEX [IX_Basic] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE  NONCLUSTERED INDEX [IX_Clustered_False] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE  CLUSTERED INDEX [IX_Clustered_True] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE  NONCLUSTERED INDEX [IX_DropExisting_False] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE  NONCLUSTERED INDEX [IX_DropExisting_True] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = ON, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE  NONCLUSTERED INDEX [IX_IgnoreDupKey_False] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE  NONCLUSTERED INDEX [IX_IgnoreDupKey_True] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = ON, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE  NONCLUSTERED INDEX [IX_Online_False] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE  NONCLUSTERED INDEX [IX_Online_True] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = ON, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = ON) ON [PRIMARY]
              GO
              
              CREATE  NONCLUSTERED INDEX [IX_PadIndex_False] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE  NONCLUSTERED INDEX [IX_PadIndex_True] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE  NONCLUSTERED INDEX [IX_SortInTempdb_False] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE  NONCLUSTERED INDEX [IX_SortInTempdb_True] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = ON, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE  NONCLUSTERED INDEX [IX_Unique_False] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE UNIQUE NONCLUSTERED INDEX [IX_Unique_True] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE  NONCLUSTERED INDEX [IX_All_False] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
              GO
              
              CREATE UNIQUE CLUSTERED INDEX [IX_All_True] ON [TestTable1] ([Column1] Asc)
              WITH (PAD_INDEX = ON, SORT_IN_TEMPDB = ON, DROP_EXISTING = ON, IGNORE_DUP_KEY = ON, ONLINE = ON) ON [PRIMARY]
              GO
            </Body>
          </Query>
        </ExecuteSQL>
      </Tasks>
    </Package>
  </Packages>
</Vulcan>